package com.xuxu.blog.dao;

import com.xuxu.blog.entity.SignEntity;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

/**
 * 
 * 
 * @author maxuxu
 * @email maxuxu019@gmail.com
 * @date 2022-08-21 22:22:31
 */
@Mapper
public interface SignDao extends BaseMapper<SignEntity> {
    @Select("select * from sign where TO_DAYS(time) = TO_DAYS(NOW()) and username= #{username}")
    SignEntity selectIsSigned(String username);
}
